package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class qjinfodid extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
              String id=request.getParameter("id");
              try {
      			Class.forName("com.mysql.jdbc.Driver");
      		} catch (ClassNotFoundException e) {
      			// TODO Auto-generated catch block
      			e.printStackTrace();
      		}
      		   String url ="jdbc:mysql://localhost:3306/graduatedesign" ;
      			  Connection conn = null ;
      			  String sql="delete from qjinfo where id="+id; 
      			  try {
      				conn = DriverManager.getConnection(url, "root", "root") ;
      				PreparedStatement preStmt=conn.prepareStatement(sql);  
      	            int suc = preStmt.executeUpdate(); 
      	            if(suc!=0){
      	            	response.sendRedirect("admin/qjinfo.jsp") ;
      	            }
      			} catch (SQLException e) {
      				// TODO Auto-generated catch block
      				e.printStackTrace();
      			}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

	}

}
